record locking

record locking
   A method used to control access to individual records in a database. In a multiuser environment, there is always the possibility that two users will attempt to update the same record at the same time but with different information. The initial attempt to solve this problem was to use file locking in which the first user to access the file locks out all other users and prevents them from opening the file. After the file is updated and closed again, the next user can gain access.
   File locking can seriously degrade overall system performance as many users attempt to access the same files time after time. To avoid this slowdown, many database management systems use record locking, which limits access to individual records within the database files.
   See also file and record locking.

Dictionary of networking . 2014.

Игры ⚽ Нужно решить контрольную?

Look at other dictionaries:

  • Record locking — is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.The classic example is demonstrated by two bank clerks attempting to update the same bank account for two different transactions. Clerk 1… …   Wikipedia

  • Record Locking —   [engl.], Datensatzsperre …   Universal-Lexikon

  • record locking — method used by a program to prevent other programs from reading or writing to a data record in order to prevent loss of data …   English contemporary dictionary

  • record locking —    A method of managing shared data on a network by preventing more than one user from accessing the same segment of data at the same time …   IT glossary of terms, acronyms and abbreviations

  • file and record locking —    A method of controlling file access in a multiuser environment, where there is always a possibility that two users will attempt to update the same file at the same time but with different information. The first user to access the file locks… …   Dictionary of networking

  • File locking — is a mechanism that enforces access to a computer file by only one user or process at any specific time. The purpose of locking is to prevent the classic interceding update scenario. The interceding update problem may be illustrated as in the… …   Wikipedia

  • File Locking —   [dt. »Dateisperre«], in einem Netzwerk ein Verfahren zum Dateischutz, durch das eine Datei während der Bearbeitung durch einen Netzteilnehmer für Zugriffe anderer Benutzer gesperrt ist. Auf diese Weise lässt sich vermeiden, dass zwei Anwender… …   Universal-Lexikon

  • file locking —    See file and record locking …   Dictionary of networking

  • Microsoft Jet Database Engine — This article is about JET Red used in Microsoft Access. For the JET Blue ISAM implementation, see Extensible Storage Engine. The Microsoft Jet Database Engine is a database engine on which several Microsoft products have been built. A database… …   Wikipedia

  • Extensible Storage Engine — For JET Red storage engine of Microsoft Access, see Microsoft Jet Database Engine. For the teacher s term, Exceptional education. Extensible Storage Engine (ESE), also known as JET Blue, is an Indexed Sequential Access Method (ISAM) data storage… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”